﻿<!DOCTYPE html>
<html>
	<head>
		<title>Formula tab</title>
		<meta charset="utf-8" />
        <meta name="description" content="Introducing the Spreadsheet Editor user interface - Formula tab" />
		<link type="text/css" rel="stylesheet" href="../../../../../../common/main/resources/help/editor.css" />
		<link type = "text/css" rel = "stylesheet" href = "../../images/sprite.css" />
        <script type="text/javascript" src="../callback.js"></script>
        <script type="text/javascript" src="../search/js/page-search.js"></script>
	</head>
	<body>
		<div class="mainpart">
            <div class="search-field">
                <input id="search" class="searchBar" placeholder="Search" type="text" onkeypress="doSearch(event)">
            </div>
			<h1>Formula tab</h1>
            <p>The <b>Formula</b> tab in the <a href="https://www.onlyoffice.com/spreadsheet-editor.aspx" target="_blank" onclick="onhyperlinkclick(this)"><b>Spreadsheet Editor</b></a> tab allows <a href="../UsageInstructions/InsertFunction.htm" onclick="onhyperlinkclick(this)">working easily with all functions</a>.</p>
            <div class="onlineDocumentFeatures">
                <p>The corresponding window of the Online Spreadsheet Editor:</p>
                <p><img alt="Formula tab" src="../images/interface/formulatab.png" /></p>
            </div>
            <div class="desktopDocumentFeatures">
                <p>The corresponding window of the Desktop Spreadsheet Editor:</p>
                <p><img alt="Formula tab" src="../images/interface/desktop_formulatab.png" /></p>
            </div>
            <p>Using this tab, you can:</p>
            <ul>
                <li>insert functions using the <b>Insert Function</b> dialog window,</li>
                <li>quickly access <b>Autosum</b> formulas,</li>
                <li>access 10 <b>recently used</b> formulas,</li> 
                <li>work with formulas classified into categories,</li>
                <li>work with <a href="../UsageInstructions/UseNamedRanges.htm" onclick="onhyperlinkclick(this)">named ranges</a>,</li>
                <li>trace <b>precedents</b> and <b>dependents</b>,</li>
                <li>show <b>formulas</b> in the cells instead of the formula results,</li>
                <li>use the <a href="../UsageInstructions/WatchWindow.htm" onclick="onhyperlinkclick(this)">Watch Window</a>,</li>
                <li>use the <b>calculation</b> options: calculate the entire workbook, or the current worksheet only<!--, as well as select the preferred calculation mode: automatically or manually-->.</li>               
            </ul>
		</div>
	</body>
</html>
